﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Tb_Core_SerialNoDataSet" targetNamespace="http://tempuri.org/Tb_Core_SerialNoDataSet.xsd" xmlns:mstns="http://tempuri.org/Tb_Core_SerialNoDataSet.xsd" xmlns="http://tempuri.org/Tb_Core_SerialNoDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DataSetFile="Tb_Core_SerialNoDataSet.Dataset.Designer.cs" DataSetProject="MobilePlatform.DomainModel" DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (Settings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.Asd.MP.Data.Properties.Settings.GlobalReference.Default.ConnectionString" Provider="Oracle.DataAccess.Client" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TB_CORE_SNTableAdapter" GeneratorDataComponentClassName="TB_CORE_SNTableAdapter" Name="TB_CORE_SN" UserDataComponentName="TB_CORE_SNTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="MP.TB_CORE_SN" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "MP"."TB_CORE_SN" WHERE (("SN" = :Original_SN) AND ((:IsNull_EMPACCOUNT = 1 AND "EMPACCOUNT" IS NULL) OR ("EMPACCOUNT" = :Original_EMPACCOUNT)) AND ((:IsNull_MOBILE = 1 AND "MOBILE" IS NULL) OR ("MOBILE" = :Original_MOBILE)) AND ("STATUS" = :Original_STATUS) AND ((:IsNull_REMARK = 1 AND "REMARK" IS NULL) OR ("REMARK" = :Original_REMARK)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_SN" Precision="0" ProviderType="Char" Scale="0" Size="36" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EMPACCOUNT" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="EMPACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EMPACCOUNT" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="EMPACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MOBILE" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="MOBILE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_MOBILE" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="MOBILE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_STATUS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_REMARK" Precision="0" ProviderType="Int32" Scale="0" Size="2000" SourceColumn="REMARK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_REMARK" Precision="0" ProviderType="Varchar2" Scale="0" Size="2000" SourceColumn="REMARK" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "MP"."TB_CORE_SN" ("SN", "EMPACCOUNT", "MOBILE", "STATUS", "REMARK") VALUES (:SN, :EMPACCOUNT, :MOBILE, :STATUS, :REMARK)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="SN" Precision="0" ProviderType="Char" Scale="0" Size="36" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EMPACCOUNT" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="EMPACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="MOBILE" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="MOBILE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="STATUS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="REMARK" Precision="0" ProviderType="Varchar2" Scale="0" Size="2000" SourceColumn="REMARK" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SN, EMPACCOUNT, MOBILE, STATUS, REMARK FROM MP.TB_CORE_SN</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "MP"."TB_CORE_SN" SET "SN" = :SN, "EMPACCOUNT" = :EMPACCOUNT, "MOBILE" = :MOBILE, "STATUS" = :STATUS, "REMARK" = :REMARK WHERE (("SN" = :Original_SN) AND ((:IsNull_EMPACCOUNT = 1 AND "EMPACCOUNT" IS NULL) OR ("EMPACCOUNT" = :Original_EMPACCOUNT)) AND ((:IsNull_MOBILE = 1 AND "MOBILE" IS NULL) OR ("MOBILE" = :Original_MOBILE)) AND ("STATUS" = :Original_STATUS) AND ((:IsNull_REMARK = 1 AND "REMARK" IS NULL) OR ("REMARK" = :Original_REMARK)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="SN" Precision="0" ProviderType="Char" Scale="0" Size="36" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EMPACCOUNT" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="EMPACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="MOBILE" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="MOBILE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="STATUS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="REMARK" Precision="0" ProviderType="Varchar2" Scale="0" Size="2000" SourceColumn="REMARK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_SN" Precision="0" ProviderType="Char" Scale="0" Size="36" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EMPACCOUNT" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="EMPACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EMPACCOUNT" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="EMPACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MOBILE" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="MOBILE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_MOBILE" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="MOBILE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_STATUS" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_REMARK" Precision="0" ProviderType="Int32" Scale="0" Size="2000" SourceColumn="REMARK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_REMARK" Precision="0" ProviderType="Varchar2" Scale="0" Size="2000" SourceColumn="REMARK" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SN" DataSetColumn="SN" />
              <Mapping SourceColumn="EMPACCOUNT" DataSetColumn="EMPACCOUNT" />
              <Mapping SourceColumn="MOBILE" DataSetColumn="MOBILE" />
              <Mapping SourceColumn="STATUS" DataSetColumn="STATUS" />
              <Mapping SourceColumn="REMARK" DataSetColumn="REMARK" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="MP.TB_CORE_SN" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   SN, EMPACCOUNT, MOBILE, STATUS, REMARK
FROM      TB_CORE_SN
WHERE   (SN = :PARAM1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PARAM1" ColumnName="SN" DataSourceName="MP.TB_CORE_SN" DataTypeServer="CHAR(36)" DbType="String" Direction="Input" ParameterName=":PARAM1" Precision="0" ProviderType="Char" Scale="0" Size="36" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Tb_Core_SerialNoDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="Tb_Core_SerialNoDataSet" msprop:Generator_UserDSName="Tb_Core_SerialNoDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="TB_CORE_SN" msprop:Generator_TableClassName="TB_CORE_SNDataTable" msprop:Generator_TableVarName="tableTB_CORE_SN" msprop:Generator_TablePropName="TB_CORE_SN" msprop:Generator_RowDeletingName="TB_CORE_SNRowDeleting" msprop:Generator_UserTableName="TB_CORE_SN" msprop:Generator_RowChangingName="TB_CORE_SNRowChanging" msprop:Generator_RowEvHandlerName="TB_CORE_SNRowChangeEventHandler" msprop:Generator_RowDeletedName="TB_CORE_SNRowDeleted" msprop:Generator_RowEvArgName="TB_CORE_SNRowChangeEvent" msprop:Generator_RowChangedName="TB_CORE_SNRowChanged" msprop:Generator_RowClassName="TB_CORE_SNRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SN" msprop:Generator_ColumnVarNameInTable="columnSN" msprop:Generator_ColumnPropNameInRow="SN" msprop:Generator_ColumnPropNameInTable="SNColumn" msprop:Generator_UserColumnName="SN">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EMPACCOUNT" msprop:Generator_ColumnVarNameInTable="columnEMPACCOUNT" msprop:Generator_ColumnPropNameInRow="EMPACCOUNT" msprop:Generator_ColumnPropNameInTable="EMPACCOUNTColumn" msprop:Generator_UserColumnName="EMPACCOUNT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MOBILE" msprop:Generator_ColumnVarNameInTable="columnMOBILE" msprop:Generator_ColumnPropNameInRow="MOBILE" msprop:Generator_ColumnPropNameInTable="MOBILEColumn" msprop:Generator_UserColumnName="MOBILE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="STATUS" msprop:Generator_ColumnVarNameInTable="columnSTATUS" msprop:Generator_ColumnPropNameInRow="STATUS" msprop:Generator_ColumnPropNameInTable="STATUSColumn" msprop:Generator_UserColumnName="STATUS" type="xs:decimal" />
              <xs:element name="REMARK" msprop:Generator_ColumnVarNameInTable="columnREMARK" msprop:Generator_ColumnPropNameInRow="REMARK" msprop:Generator_ColumnPropNameInTable="REMARKColumn" msprop:Generator_UserColumnName="REMARK" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TB_CORE_SN" />
      <xs:field xpath="mstns:SN" />
    </xs:unique>
  </xs:element>
</xs:schema>